Delete Range

AutomatR.GoogleSheets.Activities.DeleteRange

The "Delete Range" activity in AutomatR for Google Sheets allows the deletion of values in a specified range of cells and shifts the remaining cells up or left. This activity provides a powerful capability to clear specific cell ranges within a Google Sheets document, enhancing data manipulation in automation workflows.

Properties

Name	Description
Input
Range	Specifies the range of cells that need to be deleted. String variables containing the desired cell range (e.g., "A1:B5").
Miscellaneous
Display Name	Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name.
Optional
Delay	Specifies the amount of time (in seconds) to wait before executing the "Delete Range" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1.

How to Use

1. Drag and drop the "Delete Range" activity onto the workflow.
2. Configure the properties by specifying the range of cells to be deleted.
3. Optionally, configure the delay and customize the display name.
4. Execute the workflow to delete the values within the specified cell range in Google Sheets.

Example

Consider an example where the "Delete Range" activity is used to clear values in cells A1 to B5 in a sheet named "DataSheet":

Delete Range:
  Display Name: "Clear Data Range"
  Range: "A1:B5"
  Delay: 2

In this example, the activity clears the values in the specified range ("A1:B5"). The delay is set to 2 seconds to allow for proper synchronization.